UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dh2N4JK0aViEuZNaUWPHDi58gOf30EfmZshwqvleSYg='
WHERE
key_id = '2e671c13463f7082fb8d42eb8393f2768612cd753b80637d4a19f7f92ce3b6e0'
AND (
token = 'dh2N4JK0aViEuZNaUWPHDi58gOf30EfmZshwqvleSYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)