UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEjBHHcJRD0sl8ZnctigkAt5ctbRRo69wl2JtZcovp0='
WHERE
key_id = '008b37802e3d574f276dd56a196a1f384215efbe9567460977839a96db83fe15'
AND (
token = 'gEjBHHcJRD0sl8ZnctigkAt5ctbRRo69wl2JtZcovp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)