UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IxZNc/vuOPttGpOZiaWMa1uQDtHGelX/x6GUIfZSFoM='
WHERE
key_id = 'a838e8c13c241c05ad243f4e61abc412f0b2abdee8c0e03e974b2322b062cc77'
AND (
token = 'IxZNc/vuOPttGpOZiaWMa1uQDtHGelX/x6GUIfZSFoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)