UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKecPTxCKRklsOtv0WVvOCWEvrz0KF0/yKs4vlGREzo='
WHERE
key_id = '3ecd4c64e985b18791be0f044502d16f521e16ab1d3745454c4b54b569d4b385'
AND (
token = 'zKecPTxCKRklsOtv0WVvOCWEvrz0KF0/yKs4vlGREzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)