UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D+FNDKvRJR/qh89Bz7eyDQJ5M8m43J7sfWnAf+Dd3sU='
WHERE
key_id = '3e5c78386960651b1e886c3ca845fcb22bd640fc8203f0d2f1be71f99ee072c7'
AND (
token = 'D+FNDKvRJR/qh89Bz7eyDQJ5M8m43J7sfWnAf+Dd3sU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)