UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLgiMpn0SZ/dZ2KYU3I+Z+ejB7R0RjJ31IBZQ+/PDZk='
WHERE
key_id = 'b8c63be28a133ee2c36a4f3ffb06b744722137e91dd4c1ea2e24b9ac258c21cb'
AND (
token = 'xLgiMpn0SZ/dZ2KYU3I+Z+ejB7R0RjJ31IBZQ+/PDZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)