UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wiQ6MTLxXzjJICFpurFrNItk8Zyn7U8AQVZB0U2z+tk='
WHERE
key_id = 'de50efe518baaf0e24b1c3d2300ebedc5d09327472e08a5b259026cc8648f54e'
AND (
token = 'wiQ6MTLxXzjJICFpurFrNItk8Zyn7U8AQVZB0U2z+tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)