UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P3v2u8T37XREt5Nmi6SnD3zFp9wIEjRltPFnm7/QhjA='
WHERE
key_id = 'd167f4ee392473d02aa6100589f0cb2944141cdea371ab2705735ce0c6afbfd6'
AND (
token = 'P3v2u8T37XREt5Nmi6SnD3zFp9wIEjRltPFnm7/QhjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)