UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nuePNtR9Ser8KRK3KSbPt4jasNT6VG2+As0f8x4OCYw='
WHERE
key_id = 'c2516ea8baa8be27429fbd5ffcfbe09eedd721a6d43e14d66e87e31f90197a1c'
AND (
token = 'nuePNtR9Ser8KRK3KSbPt4jasNT6VG2+As0f8x4OCYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)