UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtoTaGLgE1fuff5xpn/2G8+wjreXOEuvQqXO9pqPxH4='
WHERE
key_id = '1a25fcef1362905147048cc12145d096bd9616b0ab42bd3ad35c6e7571d8ab57'
AND (
token = 'BtoTaGLgE1fuff5xpn/2G8+wjreXOEuvQqXO9pqPxH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)