UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gcQRWMsRynRdkF/aLAvN4fjJAEmfBEXKI637gXm/Tc='
WHERE
key_id = 'a968aa2e6af59552f20a1a6133d75bdc0ff0414f5b3cbc31a8495cc9612f557a'
AND (
token = '6gcQRWMsRynRdkF/aLAvN4fjJAEmfBEXKI637gXm/Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)