UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+dDVuMdwKF60yB5NB/W8t8+FrUE8MrYcjeEXG7PzPcw='
WHERE
key_id = '13253864ba5790e36be61b4e8226bcbfa4f478afc0e1ae7dde7d91d0cc989688'
AND (
token = '+dDVuMdwKF60yB5NB/W8t8+FrUE8MrYcjeEXG7PzPcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)