UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYkizZyfQi4kqCWQiOPTwcJ3llbn46EPlyvawEgHGKI='
WHERE
key_id = 'ed9214affbe54128f64b91d2a7478518337fb1c6c4248162a0248efedc044f39'
AND (
token = 'XYkizZyfQi4kqCWQiOPTwcJ3llbn46EPlyvawEgHGKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)