UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GDCeUFS/r8htBwhGhZgw9vKC9SRdvoZzqXmqFHzHQQo='
WHERE
key_id = '6811691547d6567b5f9d80e42a191600b106b1c7c11157263e26f8b0ed1306f2'
AND (
token = 'GDCeUFS/r8htBwhGhZgw9vKC9SRdvoZzqXmqFHzHQQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)