UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjBGBPqNaQDh3uL6lEQuqst1BOKyOgiYObP2T7yWtiQ='
WHERE
key_id = '1f2142c545f5af09db863365ba1883fb91afb9d500126afa83292badc058c598'
AND (
token = 'BjBGBPqNaQDh3uL6lEQuqst1BOKyOgiYObP2T7yWtiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)