UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1254dcrTY+UiGOokAQEY24vmYqWZQU3iu3xJ1FL+lgA='
WHERE
key_id = '7a4b956e74d166497bf6584a6cc84e0cd41a39b2f1d7c464028efeff86c66952'
AND (
token = '1254dcrTY+UiGOokAQEY24vmYqWZQU3iu3xJ1FL+lgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)