UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4X3dS50+sr/CtRaOXK8rByC2cdZ8eZS2SBpRE7O7RAk='
WHERE
key_id = 'cc71bc7fa0e87986dd26dd625f64b45b48c98a97436d89ce54f347485fd4a278'
AND (
token = '4X3dS50+sr/CtRaOXK8rByC2cdZ8eZS2SBpRE7O7RAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)